<%-- 
    Document   : products
    Created on : Feb 8, 2012, 6:16:45 PM
    Author     : Alex
--%>

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
        <style type="text/css">
body {
	background-color: #000;
	background-image: url(bg.jpg);
	background-repeat: repeat-x;
}
body,td,th {
	font-family: Verdana, Geneva, sans-serif;
	font-size: 7pt;
	color: #FFF;
}

h1 { font-family:Verdana, Geneva, sans-serif; font-size:24; text-align:center;}
h2 { font-family:Verdana, Geneva, sans-serif; font-size:10px; color:white;}
h3 { font-family:Verdana, Geneva, sans-serif; font-size:30; color:white; text-align:center;}

   </style>
   <script language = "Javascript" type="text/javascript">

function OnBlurInput(blur){

			if(blur.value == "")
			{
		    blur.value = "";
			}

}

function OnBlurInputPass(blur){

			if(blur.value == "")
			{
		    blur.value = "";
			}

			if(blur.value == "Password" || blur.value == "Retype Password" )
			{
			blur.type = "text";
			blur.value = blur.defaultValue;
			}


}

function OnClickInput(click){

			if(click.value == click.defaultValue )
			{
				click.value = "";
			}


}

function OnClickInputPass(click){

			if(click.value == click.defaultValue )
			{
				click.value = "";
			}
			if(click.type == "text")
			{
			click.type = "password";

			}

}
</script>


    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>FooBar Bookstore</title>
    </head>
    
        <body>
          <%
            try{

            String connectionURL = "jdbc:mysql://localhost:3306/practicesecprog";
            // declare a connection by using Connection interface
            Connection connection = null;
            /* declare object of Statement interface that is used for executing sql
            statements. */
            Statement statement = null;
            // declare a resultset that uses as a table for output data from tha table.
            ResultSet rs = null;
            ResultSet rs2= null;
            // Load JBBC driver "com.mysql.jdbc.Driver"
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            /* Create a connection by using getConnection() method that takes parameters
            of string type connection url, user name and password to connect to database.*/
            connection = DriverManager.getConnection(connectionURL, "root", "1234");
            /* createStatement() is used for create statement object that is used for
            sending sql statements to the specified database. */
            statement = connection.createStatement();
            // sql query to retrieve values from the secified table.
            %>


            <%
            String QueryString = "SELECT title from product";
            rs = statement.executeQuery(QueryString);
            %>

 
            <%
            while (rs.next()) {
            %>

            <h2>Products:</h2> <%=rs.getString(3)%><br>
            
            <% } %>
<%
// close all the connections.
rs.close();
statement.close();
connection.close();
} catch (Exception ex) {
%>


<font size="+3" color="red"></b>
<%
out.println("Unable to connect to database.");
}
%> 
        </font>


        
        
        
        
    </body>
</html>


















